Prerequisites

Before you can use Microsoft SQL Server as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Client

Microsoft SQL Server Native Client must be installed on the Qlik Compose machine.

Permissions

To use Microsoft SQL Server as a Data Warehouse a Qlik Compose project, the Compose user must be granted the following privileges in the Microsoft SQL Server database:

• The Qlik Compose user must have at least the db_owner user role on the Microsoft SQL Server database.
• The Qlik Compose user must be granted the CREATE VIEW permission on the Microsoft SQL Server database.
• A Microsoft SQL Server system administrator must provide this permission for all Qlik Compose users.